﻿using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace ExceptionService
{
    /// <summary>
    /// Summary description for VersionHandler
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [ToolboxItem(false)]
    

    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    // [System.Web.Script.Services.ScriptService]
    public class VersionHandler : System.Web.Services.WebService
    {

        [WebMethod]
        public string IsNewVersionAvailable(string version)
        {
            string st="";
          
                SqlConnection con = new SqlConnection(Properties.Settings.Default.DBConn);
                con.Open();
                SqlCommand cmd = new SqlCommand("GetNextVersion", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@version", SqlDbType.NVarChar).Value = version;
                st = (string)cmd.ExecuteScalar();
                if (st == null)
                    st = "";
         
               // ExceptionHandler a = new ExceptionHandler();
               // a.HandleException("VersionHandler", e.Message , e.Source , e.StackTrace , e.TargetSite.ToString(), "VersionHandler", "VersionHandler", "VersionHandler", "VersionHandler", "VersionHandler", "VersionHandler", "VersionHandler", "VersionHandler", "VersionHandler");
           
            return st;
        }
    }
}
